FO_MergeTable_Definitions
Table used to establish alias/cross reference of data elements for merge process since same data element might be posted to multiple tables.
Field | Type | Notes |
---|---|---|
MergeTables_ID |
int |
ID field, a counter. Unique |
Active |
bit |
Bit flag to indicate if this record is active. Enter 0 or 1 0 = inactive (FALSE) 1 = active (ACTIVE) |
TableName |
varchar(50) |
Enter a valid database table name. |
PT_ID |
varchar(50) |
Enter a valid column name for patient row identifier. Do not enter a column name that is a table’s primary key, for example, for the FO_Acc_Pts or FO_Patients tables. |
FOID |
varchar(50) |
Enter a valid column name for FOID. |
MRN |
varchar(50) |
Enter a valid column name for MRN, medical record number. |
MRNHID |
varchar(50) |
Enter a valid column name for MRN/Facility ID. |
Acct |
varchar(50) |
Enter a valid column name for account. |
EpisodeID |
varchar(50) |
Enter a valid column name for episode ID. Do not enter a column name that is a table’s primary key, for example, for the FO_Episodes table. |
LIS_Episode |
varchar(50) |
Enter a valid column name for lab system episode number. |
SSN |
varchar(50) |
Enter a valid column name for social security number. |
PtName |
varchar(50) |
Enter a valid column name for patient name. |
PtDOB |
varchar(50) |
Enter a valid column name for patient date of birth. |
PtGender |
varchar(50) |
Enter a valid column name for patient gender. |
UniqueAcc |
varchar(50) |
Enter a valid column name for unique accession number. |
Accession |
varchar(50) |
Enter a valid column name for FAST accession number. |
LabAcc |
varchar(50) |
Enter a valid column name for lab accession number. |
PIDX |
varchar(50) |
Enter a valid column name for lab system internal patient identifier. |
ORDX |
varchar(50) |
Enter a valid column name for lab system internal order identifier. |
FacilityID |
varchar(50) |
Enter a valid column name for facility ID. |
CreateDate |
datetime |
Date record was created. Informational |
EditDate |
datetime |
Date record was last edited. Informational |
Last_Name |
varchar(50) |
Enter a valid column name for patient last name. |
First_Name |
varchar(50) |
Enter a valid column name for patient first name. |
MI |
varchar(50) |
Enter a valid column name for patient middle initial. |